<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>Tolc: app/common/utils_db.php Source File</title>
<link href="../../tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="../../jquery.js"></script>
<script type="text/javascript" src="../../dynsections.js"></script>
<link href="../../navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="../../resize.js"></script>
<script type="text/javascript" src="../../navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="../../search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="../../search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="../../doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="../../tolc_logo.png"/></td>
  <td style="padding-left: 0.5em;">
   <div id="projectname">Tolc
   &#160;<span id="projectnumber">v 1.00</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.2 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "../../search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="../../index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="../../pages.html"><span>Related&#160;Pages</span></a></li>
      <li class="current"><a href="../../files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="../../search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="../../search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="../../files.html"><span>File&#160;List</span></a></li>
      <li><a href="../../globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('d2/d1c/utils__db_8php_source.html','../../');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Pages</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">utils_db.php</div>  </div>
</div><!--header-->
<div class="contents">
<a href="../../d2/d1c/utils__db_8php.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;&lt;?php</div>
<div class="line"><a name="l00010"></a><span class="lineno"><a class="code" href="../../d2/d1c/utils__db_8php.html#a9130b08511e6b3e5efd303a8cb48b4e8">   10</a></span>&#160;<span class="keyword">function</span> <a class="code" href="../../d2/d1c/utils__db_8php.html#a9130b08511e6b3e5efd303a8cb48b4e8">get_db_conn</a>($driver) {</div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;</div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;        global <a class="code" href="../../de/dc4/settings_8dist_8php.html#af21c418e4c577deb3a9ea7299156ae35">$tolc_conf</a>;</div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;</div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;        <span class="keywordflow">switch</span>($driver) {</div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;mysql&#39;</span>:</div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;mysqlt&#39;</span>:</div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;mysqli&#39;</span>:</div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;                        $dsn = $driver . <span class="stringliteral">&#39;://&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dbuser&#39;</span>] . <span class="charliteral">&#39;:&#39;</span> . rawurlencode($tolc_conf[<span class="stringliteral">&#39;dbpass&#39;</span>]) .</div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;                                <span class="charliteral">&#39;@&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dbserver&#39;</span>] . <span class="charliteral">&#39;/&#39;</span> .</div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;                                $tolc_conf[<span class="stringliteral">&#39;domains_db&#39;</span>][$_SERVER[<span class="stringliteral">&#39;SERVER_NAME&#39;</span>]] .</div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;                                <span class="stringliteral">&#39;?persist=&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dsn_options_persist&#39;</span>] . <span class="stringliteral">&#39;&amp;fetchmode=&#39;</span> . ADODB_FETCH_ASSOC . $tolc_conf[<span class="stringliteral">&#39;dsn_options_misc&#39;</span>];</div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;                        <a class="code" href="../../d5/d3e/ajax__autocomplete__parent__title_8php.html#aa8a5a87b9c1a6a0819b88447cbe41877">$conn</a> = NewADOConnection($dsn);</div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;                        <a class="code" href="../../d5/d3e/ajax__autocomplete__parent__title_8php.html#aa8a5a87b9c1a6a0819b88447cbe41877">$conn</a>-&gt;execute(<span class="stringliteral">&#39;SET NAMES UTF8&#39;</span>); <span class="comment">// TODO it is required with 5.3.3-7+squeeze14, but not needed with (Arclinux) php 5.4.4</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;                        <span class="keywordflow">return</span> <a class="code" href="../../d5/d3e/ajax__autocomplete__parent__title_8php.html#aa8a5a87b9c1a6a0819b88447cbe41877">$conn</a>;</div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;postgres&#39;</span>:</div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;firebird&#39;</span>: <span class="comment">// TODO not tested</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;                        $dsn = $driver . <span class="stringliteral">&#39;://&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dbuser&#39;</span>] . <span class="charliteral">&#39;:&#39;</span> . rawurlencode($tolc_conf[<span class="stringliteral">&#39;dbpass&#39;</span>]) .</div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;                                <span class="charliteral">&#39;@&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dbserver&#39;</span>] . <span class="charliteral">&#39;/&#39;</span> .</div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;                                $tolc_conf[<span class="stringliteral">&#39;domains_db&#39;</span>][$_SERVER[<span class="stringliteral">&#39;SERVER_NAME&#39;</span>]] .</div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;                                <span class="stringliteral">&#39;?persist=&#39;</span> . $tolc_conf[<span class="stringliteral">&#39;dsn_options_persist&#39;</span>] . <span class="stringliteral">&#39;&amp;fetchmode=&#39;</span> . ADODB_FETCH_ASSOC . $tolc_conf[<span class="stringliteral">&#39;dsn_options_misc&#39;</span>];</div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;                        <a class="code" href="../../d5/d3e/ajax__autocomplete__parent__title_8php.html#aa8a5a87b9c1a6a0819b88447cbe41877">$conn</a> = NewADOConnection($dsn);</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;                        <span class="keywordflow">return</span> <a class="code" href="../../d5/d3e/ajax__autocomplete__parent__title_8php.html#aa8a5a87b9c1a6a0819b88447cbe41877">$conn</a>;</div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;                        <span class="keywordflow">break</span>;</div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;sqlite&#39;</span>:</div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;oci8&#39;</span>: <span class="comment">// TODO not tested</span></div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;                        <span class="keywordflow">return</span> NewADOConnection($tolc_conf[<span class="stringliteral">&#39;dsn_custom&#39;</span>]);</div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;                        <span class="keywordflow">break</span>;</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;access&#39;</span>:</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;db2&#39;</span>: <span class="comment">// TODO not tested - possible &amp; must be removed for php &gt; 4</span></div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;                        $db =&amp; ADONewConnection($driver);</div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;                        $db-&gt;Connect($tolc_conf[<span class="stringliteral">&#39;dsn_custom&#39;</span>]);</div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;                        <span class="keywordflow">return</span> $db;</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;                        <span class="keywordflow">break</span>;</div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;                <span class="keywordflow">case</span> <span class="stringliteral">&#39;odbc_mssql&#39;</span>: <span class="comment">// TODO not tested - possible &amp; must be removed for php &gt; 4</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;                        $db =&amp; ADONewConnection($driver);</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;                        $db-&gt;Connect($tolc_conf[<span class="stringliteral">&#39;dsn_custom&#39;</span>], $tolc_conf[<span class="stringliteral">&#39;dbuser&#39;</span>], $tolc_conf[<span class="stringliteral">&#39;dbpass&#39;</span>]);</div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;                        <span class="keywordflow">return</span> $db;</div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;                        <span class="keywordflow">break</span>;</div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;        }</div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;}</div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;?&gt;</div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="../../dir_d422163b96683743ed3963d4aac17747.html">app</a></li><li class="navelem"><a class="el" href="../../dir_4a9513260508d5894bea9849c69369f8.html">common</a></li><li class="navelem"><a class="el" href="../../d2/d1c/utils__db_8php.html">utils_db.php</a></li>
    <li class="footer">Generated on Fri Aug 31 2012 22:06:31 for Tolc by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="../../doxygen.png" alt="doxygen"/></a> 1.8.2 </li>
  </ul>
</div>
</body>
</html>
